Excel page break not working

@RCully But your initial post was that you didn't have the "Automatic" setting.  Now you mention that Excel doesn't automatically print 1 high by 2 wide. Well, isn't that obvious?

Played around a little with page setup and it seems that "Automatic" scaling sets the pages to max 640 pixels wide and max 960 pixels high. Leaving it to Automatic will, in your case, print 8 by 8. If that's not what you want you need to override the Automatic setting and explicitly tell Excel to print 1 wide by 2 high. And when you have done that, you will notice that the scaling percentage will have automatically been set to whatever scaling achieves that. No need to do that by trial and error.